﻿CREATE TABLE [dbo].[Visitor] (
    [ID]                   BIGINT         IDENTITY (1, 1) NOT NULL,
    [Twitter_ID]           BIGINT         NOT NULL,
    [Name]                 NVARCHAR (50)  NULL,
    [Screen_Name]          NVARCHAR (50)  NOT NULL,
    [Url]                  NVARCHAR (300) NULL,
    [Profile_Image_Url]    NVARCHAR (300) NULL,
    [Description]          NVARCHAR (50)  NULL,
    [Friends_Count]        INT            NULL,
    [Followers_Count]      INT            NULL,
    [Time_Zone]            NVARCHAR (50)  NULL,
    [Location]             NVARCHAR (50)  NULL,
    [Listed_Count]         INT            NULL,
    [Statuses_Count]       INT            NULL,
    [Favourites_Count]     INT            NULL,
    [Verified]             BIT            NULL,
    [Geo_Enabled]          BIT            NULL,
    [Language]             NVARCHAR (50)  NULL,
    [Created_On]           DATE           NULL,
    [Protected]            BIT            NULL,
    [Contributors_Enabled] BIT            NULL,
    [LastLogin]            DATETIME       NULL,
    [LoginCount]           INT            NOT NULL,
    [AccountStatusID]      INT            NOT NULL
);

